SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513365 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513365 [ RunTime:0.002867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009024,383942,311911,808058,881245,351627,899411,23073,903060,720015,647221,427787,553463,589372,756838,482404,170896,38331,436827,239702,650495,576515,105551,2110,1040748,680714,241335,329856,838853,930159,246701,128764,1009644,872820,4605,2321,989503,126644,802051,537457,315895,444507,194541,35950,1017726,223312,351479,808356,280542,769220,364037,162468,143591,448477,22849,818554,785265,997456,860979,199588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000830s ]