SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039440 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039440 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29056,60029,627677,980905,387213,607902,949821,48534,835753,663393,250110,229766,616235,312822,137892,891128,906999,158037,1029568,450535,616444,1009673,27372,79372,1046224,224266,601827,939285,73702,763799,269066,267910,612356,524692,322858,455302,348949,742892,484587,450581,516225,744778,712675,475764,866641,988820,600616,494288,655369,783738,908681,922117,17560,189469,7154,580639,350262,93624,546815,589420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]