SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400359 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400359 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180427,225144,729841,774825,124383,1027343,315716,448048,665154,191103,287587,424293,177264,1006814,153169,814022,170136,147742,455394,403505,541977,624820,201220,1000768,452330,11252,260125,635,249288,942273,424532,800109,393286,211921,141408,709057,169180,797953,987998,512830,452722,834933,427986,206481,725815,519601,381518,239029,942510,519821,688342,99954,915676,666268,703727,478724,123059,214154,418467,647966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400359 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400359 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]