SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402786 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402786 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219598,580297,1021875,129480,1007883,77616,556551,488944,855959,897558,837438,1026224,82324,79237,589701,62619,171245,516569,835891,921519,569453,211092,766416,323242,128130,1026019,203598,646140,414500,504013,1001038,699140,148398,152149,475835,189319,863029,285840,143044,655692,567800,976001,350882,499480,435659,811314,47632,187782,735169,371366,238962,238155,1018230,96097,440707,137790,59943,853992,568457,956330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]