SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295401 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295401 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617415,536548,918557,947372,741022,318809,448116,253728,872953,430499,941231,876961,359995,506457,647027,770066,826079,1035731,243930,999144,711285,214592,829063,1046384,491179,753294,92676,112329,408944,570526,212468,301455,499603,288871,212689,311799,427558,930892,739434,602040,578132,625750,1001037,615532,851002,998932,648145,1013719,172802,319535,287178,486552,754986,694022,954342,545392,175457,951818,1027174,298426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]