SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514346 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514346 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565110,445071,483529,589748,357771,550060,707818,63073,321371,1040311,175591,492568,302754,887403,735748,950055,90151,924467,503651,129044,967640,1012844,227443,833601,734097,218844,972968,40298,437994,278330,377908,38679,424812,149695,340425,982787,148205,436913,336548,870204,560431,636040,574930,722022,242953,834945,413608,198329,1041146,851308,8474,587088,413003,495092,718189,495671,58182,589865,756837,1020952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]