SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300106 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300106 [ RunTime:0.004708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421467,83773,979616,217092,788488,42031,722973,930287,637202,498210,1023256,607171,134255,237061,1007444,74391,961421,106384,867681,134899,607447,668514,978323,720346,660652,575109,150604,987094,582013,71068,1042138,341568,1031214,870230,1016971,280333,415219,202335,1036121,395447,118946,822711,236655,1013800,404194,124040,791127,139971,773200,481357,662,35767,641499,272551,1043970,829145,27725,607444,912610,957154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]