SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400026 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400026 [ RunTime:0.003897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285950,868010,205347,913076,81531,196320,1002631,268205,855076,302954,293079,624816,679640,755435,650852,990323,417704,516415,128329,179496,176004,1041112,45986,250294,87112,676493,545545,334976,1044056,1006812,193548,638790,927145,686063,504858,456271,1002464,1038434,256075,140099,263173,930330,511016,478250,497116,709815,714453,382612,396599,200367,740451,54876,447753,925401,693077,268048,577801,790365,444109,624504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]