SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568525 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568525 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301926,542094,892761,280354,138196,895952,234305,68920,579030,104299,732910,743360,716012,784296,326942,750715,655364,46029,1003661,1048689,923111,329639,885118,43566,800164,435188,1024683,987715,338174,629216,835536,1014783,652448,338505,558526,520680,721730,965168,633004,582565,565252,73410,58839,401101,728308,828707,846023,1038116,982586,251168,827300,378962,580578,827633,388164,723686,12209,502141,331001,271053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]