SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672018 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672018 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398198,985121,992249,20602,107427,679612,385509,911493,733769,912315,317743,59797,778906,805869,745597,532277,779441,460404,346855,712124,866443,838262,886370,137795,802447,142119,335648,593647,628173,285213,814364,861485,711171,174738,894251,667143,595204,954238,903099,401195,94963,13861,262995,915634,191600,59956,563092,1042694,260715,494479,1018396,677834,838308,1017520,418026,528984,1033157,695033,444735,68423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]