SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3905 LIMIT 1 [ RunTime:0.003863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3905 [ RunTime:0.004805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3537,359546,572981,996370,45229,856564,384935,567461,498958,500049,822191,1026428,781873,569326,492511,840619,1016654,84303,675983,429823,883980,408701,1024265,1031170,594461,474435,56670,97990,989351,961891,313249,216567,320613,502891,623265,557768,581731,919254,533934,469073,259452,758823,1047709,460394,745327,566579,927532,240046,734090,916066,119086,296877,299651,139145,975474,417797,474729,136581,801176,1016778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002421s ]