SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033036 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033036 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229823,353940,1019487,109862,296135,100078,525700,282610,278547,725847,754437,1036179,15603,134910,508566,624160,127634,523222,677482,962935,811227,554712,911282,819576,649819,962906,949993,107305,681943,959401,204162,73973,169969,466449,668035,415035,170032,868755,921507,895964,240641,3294,987913,977353,318479,132866,205172,875086,1012734,245528,437850,119050,943365,343895,340861,822320,60765,618615,32360,370636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001665s ]