SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403216 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403216 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576964,911715,505064,114318,138620,845404,351526,569527,482964,160705,350863,92035,789546,691016,401440,815493,1001720,531844,248898,469492,545211,260778,812499,658010,710274,47972,91591,302947,951436,387548,991220,595052,581876,255186,997643,178126,688751,893951,14903,574648,1039743,907464,670596,652719,126406,705215,249167,249763,213887,910497,113284,814921,539435,82640,839840,159996,918625,764524,254907,827922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]