SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51986 LIMIT 1 [ RunTime:0.001534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51986 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452816,308111,31379,23377,347608,190378,361173,181025,327581,84242,645174,851129,739450,299057,399928,313435,1036032,788319,802261,421382,190139,455451,514881,722874,110739,913795,728892,859551,132181,418865,231960,354060,676832,152881,71568,63660,772780,990256,365934,734706,9674,978981,653394,446832,516509,219176,461472,904066,641745,827018,659028,300837,383530,164196,1042922,580389,842262,883244,816171,674437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]