SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554909 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554909 [ RunTime:0.002762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956699,533051,138226,704377,742899,476957,932450,543410,426124,190182,536909,360489,789917,736471,734119,584700,643027,177230,65793,99300,169063,559271,404337,435504,970075,591860,984993,890907,555752,250162,879350,948541,631713,152455,571827,727891,395423,516522,266678,235292,1023316,529204,610490,816337,984323,898173,383520,513160,619577,227164,820676,216121,117576,167480,889057,844475,513896,307514,222531,1004555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]