SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014784 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014784 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172123,13282,901698,553437,130046,315690,646168,73322,640104,875554,924492,390602,683170,364120,451504,97235,379808,311986,604858,329165,779979,780982,666137,166435,1015816,654233,620175,873355,86597,546649,1008408,167743,498011,186260,670284,339311,831706,879115,422535,801893,327741,397450,425314,308738,670120,117446,929820,1722,587793,1029049,823493,274267,147804,263165,261080,829273,233056,16931,811376,126733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014784 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014784 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]