SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028912 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028912 [ RunTime:0.001388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964647,365740,188835,889293,581787,795254,721296,816538,196680,338221,566576,214177,755801,920405,75624,571329,8165,872210,358840,430743,940787,260863,566163,762318,729628,825167,916673,1015332,436961,559908,563912,326149,59011,629525,114581,390463,631288,50027,947218,219909,354125,892051,969184,598223,174919,102856,609627,261785,799922,560024,425070,8407,463136,296317,1028286,953606,952445,155205,282095,67860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]