SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436800 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436800 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749866,280706,695039,120558,308367,259645,68897,41719,142019,556400,786401,114388,55722,826264,872000,641977,106974,802210,892993,214827,487180,430820,914012,924122,440899,425356,198241,974971,1005498,820167,15131,196332,905041,518652,591071,359282,876448,699121,278285,697632,651499,155995,359638,166004,654203,214816,522164,13227,892493,425343,53356,384473,374202,933645,471725,225179,840002,416725,648196,945220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]