SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506003 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506003 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401753,15019,618088,577204,464424,964044,108493,363800,793774,980185,736604,82752,829746,432167,1017547,777504,232161,912506,870341,287282,533999,61424,821667,840315,626577,508864,118572,574619,560602,185820,816701,142230,163326,213631,689672,329477,20369,96943,251501,60873,173290,434611,49062,121069,966531,390599,757987,734842,600202,669539,410203,236870,304330,1008812,549808,407507,926222,952690,106084,205310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]