SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326177 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326177 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319488,518457,435329,464226,334480,295100,409745,633715,79633,879181,838040,453176,874216,729291,399998,718368,944925,137418,77151,550329,633314,641452,336982,110363,717397,304978,667457,656762,462796,37725,10519,719799,201231,75610,114441,188647,345546,565089,688217,592102,759290,10965,562244,752228,102908,747279,909186,269581,15040,374126,140604,436945,1034940,379007,98750,567123,184441,407901,717939,898228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]