SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023039 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023039 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600849,977862,581204,125626,183800,670491,454858,300935,774423,608139,975470,92969,480685,512508,953620,220938,124042,731125,201884,952860,970054,746488,991098,811520,438615,538880,365844,197687,161512,770081,697740,987805,126696,780924,683965,868742,619922,52763,595862,625257,912887,305456,550114,752625,55757,32031,264990,641894,59016,71983,1043295,787591,545874,893920,395636,921892,474433,942141,758681,652313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]