SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594012 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594012 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283653,1002473,638605,724804,720262,1047910,714808,183439,244111,1002165,152525,657622,868523,1016207,123110,595217,262084,74267,736216,454692,164607,595269,543663,567159,125420,529494,955047,272875,662605,238931,525663,189696,196793,240991,108952,288164,290406,40213,529002,256538,195287,993112,1016812,115603,961275,260211,121998,215407,526172,179496,1040439,100285,556288,910295,821669,626817,453009,771764,1022864,1046117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]