SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199910 LIMIT 1 [ RunTime:0.000846s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199910 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399383,434813,670333,216288,102572,361195,716325,369488,298082,385341,336423,184677,905359,749455,418271,565573,951613,41069,28460,331063,513772,301160,309869,563423,314800,901837,127635,922967,967936,650825,504429,739277,142482,513320,407971,651513,451905,432785,55343,156528,589945,85196,817467,268559,235773,274812,531063,235654,959535,197159,442517,796963,649313,521819,903226,4165,78588,713740,1004937,967227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.033764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002122s ]