SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554580 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554580 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207945,999068,629989,447995,883401,250216,986306,903231,775467,127887,142861,861493,159308,818718,275847,781852,499436,413558,764268,148948,56366,100241,425243,867403,316173,1029901,311968,491745,358695,618297,202073,733853,409374,610170,223139,567145,856727,464790,54546,191847,358676,20487,1033286,58719,908825,380407,121308,784030,454249,457419,54032,325647,396410,947995,718092,355227,767734,969694,82514,937288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]