SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038423 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038423 [ RunTime:0.003167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563242,1036544,551815,955842,951573,836220,214011,839001,365044,658986,822701,606618,181975,804789,144882,599191,815365,800590,466100,501551,324264,940624,655359,445871,136340,839317,659757,476720,757093,579505,985556,331559,408798,2276,888846,955726,704704,310222,813990,754582,588066,150669,727307,906388,938741,669395,797788,1003316,317332,198550,843970,170681,906766,458135,155127,602509,953050,107928,472881,1032247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]