SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40238 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40238 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787970,564618,214226,90177,347290,823972,464446,1001691,693997,12544,718140,843483,136859,254641,533749,571017,349467,878,673999,165973,29206,1022102,1034902,102945,219728,1026355,9389,292342,295786,309377,322483,27928,31434,275822,634880,375653,734322,88127,159172,111554,490511,224727,973245,202620,307403,597169,773405,384638,925120,538577,816066,171450,116178,370885,5630,273105,541410,531604,39412,212211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]