SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468346 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468346 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485856,507309,989844,663132,895920,803595,97602,494758,124106,517237,162190,412119,281271,871597,542477,823117,990883,897395,383996,1000100,750306,290660,768484,206011,703064,455415,901354,922683,347249,294837,539388,738099,92171,837069,417275,791274,254412,945560,565999,248030,394288,756128,870827,224880,80333,690641,557582,582360,974864,508489,889024,295582,724214,753178,695270,752193,513898,502239,935529,238774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000930s ]