SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006483 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006483 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199502,286969,415020,139898,563481,522422,442840,988209,471671,933729,513815,82564,101032,978208,452631,446166,866564,738059,199847,338087,999203,281857,270601,1023899,588391,478524,327762,321588,844611,683384,975857,854918,777531,206126,563495,155216,934862,401787,438892,362524,219551,614568,678653,881050,238201,734661,759037,995508,924766,269501,989995,204475,986757,919349,387635,1027254,274102,106733,877407,637081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002222s ]