SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536581 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536581 [ RunTime:0.002713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378794,864911,683842,156112,215658,847209,274714,100647,571640,84130,922966,602806,99288,443129,1018257,344331,874396,116830,558938,140803,1005678,616624,441530,139010,270046,241206,570921,674380,722241,463974,356552,920402,132293,863515,797555,504164,779664,311487,906714,669585,442226,911460,563709,864388,561434,189107,852346,162652,859657,928701,455905,261060,632404,778800,842240,1028124,463407,440576,177572,168571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]