SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597299 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597299 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802524,851135,565196,388055,749619,798384,845457,1043840,100560,464758,23945,56428,814636,693897,851730,101068,104177,979016,784660,847435,238819,845265,868848,188846,678087,196070,1002216,661999,797514,482057,871484,870978,160437,522464,297138,302756,579114,598547,426490,223504,977295,704873,1020768,987842,117944,46777,3465,123780,643524,962771,484568,21650,248960,117775,260940,381886,961725,612647,368187,853909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000369s ]