SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580113 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580113 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264805,895121,505706,372442,588619,203100,377473,848713,800093,1009298,876860,692842,939632,408446,597216,905354,822375,458158,296872,336160,904478,294731,230587,761131,139138,832607,71269,1004768,805195,901183,357404,483861,486055,472779,302696,940547,897956,919926,117789,912958,308000,736227,133225,466616,329334,34674,136025,524236,531445,232591,576845,346404,250145,648952,29385,682855,784883,173473,826977,384061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]