SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3614 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3614 [ RunTime:0.002554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540514,411986,969303,841826,805022,117080,273399,1044665,915797,942988,922980,316138,5784,675995,17708,881999,873301,674443,610673,33135,703664,485250,521450,909354,549686,914915,558253,578093,188464,287086,1019107,140479,332012,892342,149336,539163,165218,980822,861049,182355,687989,770596,582005,949067,407840,209238,513256,784203,1013072,979083,1026756,780622,110094,578130,444639,460389,1007623,164514,959983,538899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002340s ]