SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312053 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312053 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31592,424622,243920,65759,87033,715251,901532,43780,855052,700041,523163,614831,537968,568857,191669,536837,784152,442684,896455,307426,531278,977823,22709,350441,402868,179645,772516,689509,672375,646586,855161,452919,843175,126564,996012,1024031,161184,117899,934805,101002,523098,467728,494041,657046,529281,210025,26202,86203,963100,405504,882682,867898,479359,273816,677873,786330,899748,431829,548531,1039290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]