SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541682 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541682 [ RunTime:0.003245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630016,678503,578907,434451,274417,320857,763882,121485,938759,256356,143064,657944,603157,326948,23020,850346,509589,345563,155978,1048491,846014,239840,409240,1002405,807514,851065,720289,1036097,583200,280668,13668,288690,614074,678745,837929,572463,698772,74220,696070,280186,999784,329726,450807,819474,979343,357200,366634,677749,301142,610011,204380,395394,812394,836919,283327,729784,541281,628400,959846,426470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]