SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017102 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017102 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810912,147319,84595,242758,912966,18837,377543,17430,971825,32183,27706,778375,358663,642837,560276,415146,931066,68933,202992,576103,460146,594412,397287,177354,516674,820128,363698,937175,299900,950635,594113,997401,652434,88706,635071,221889,325846,180184,3795,1024266,914070,272591,979497,52966,588149,312608,774388,132310,354539,188925,164793,574686,679292,98972,445207,749180,454248,590998,150831,16199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]