SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145180 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145180 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517512,30426,730015,902737,964104,371554,1007362,788237,428988,66161,866001,168394,417924,658768,674498,628347,110500,597037,326910,79398,147924,286962,808467,544943,925192,938700,456928,339162,824237,281650,33041,730991,1032915,382450,108777,744699,209259,389866,828966,140182,319144,318259,512025,397849,162634,412898,741349,67140,410238,39488,240204,331830,58499,280176,14322,109116,854390,336003,298306,287691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]