SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35813 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35813 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363821,917402,427170,985088,726320,259573,416365,395910,361963,1011522,649499,1025433,815092,151362,512881,309137,489140,429381,633344,618015,692815,689840,816958,308213,1026090,202707,852589,402613,534147,350458,768096,986971,304099,160689,190525,289569,858059,503244,342241,935484,650551,82532,77411,247769,933760,199452,955844,563831,489836,435849,794138,823211,505125,841574,225089,588597,878818,564428,807217,656642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]