SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042678 LIMIT 1 [ RunTime:0.000937s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042678 [ RunTime:0.003263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011996,352141,854961,679402,321100,198715,478116,737727,972390,900695,494408,688952,182778,188089,822781,522471,14657,478401,851635,763354,233787,259764,513210,116958,583579,150699,571541,635120,160574,423315,43262,687835,89382,254577,494614,197010,624729,894261,78822,292353,949354,572673,378272,742329,860261,127135,34411,1007818,97823,304092,55709,916203,769969,180270,917082,22025,962025,310896,27542,71120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001139s ]