SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 86100 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 86100 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50294,155731,142358,204129,1022474,481584,625636,376568,725328,770272,198892,404359,31286,453679,1035828,89207,652135,384313,964582,148867,654951,90196,411811,906912,109610,935634,953209,125220,781031,131322,602271,942637,173304,47280,226266,696286,57617,312848,166179,425126,633898,183205,1031846,659018,687879,257776,438109,427343,621231,500929,716003,530877,724445,112401,184492,626093,616136,759783,609250,709535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 86100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 86100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]