SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468036 LIMIT 1 [ RunTime:0.001313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468036 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002551,851520,586829,14261,516405,405944,290921,560680,806409,773019,911039,54899,891333,1008763,684364,316873,589181,487777,466520,106525,525320,45510,922595,390714,895119,809601,900041,462016,288683,648647,746450,520575,314905,626228,407487,67098,858072,505192,203107,861916,366109,433222,717263,802021,448703,299426,413826,844950,37652,245249,526535,303825,813635,889341,641283,1044129,64518,673803,792898,6205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]