SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420470 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420470 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341765,259651,706497,142388,26813,449565,687170,777884,158783,91781,251034,328650,4455,535672,509249,993980,982202,142263,703808,204036,977299,464398,550065,1013414,837528,617222,336114,857584,906213,498652,973628,49864,673554,168782,851764,155800,2990,294648,938197,748493,440760,210538,283912,922840,126573,38421,903850,227137,404167,806323,853617,569188,706210,300178,193642,800876,583116,720394,622133,19616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]