SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668650 LIMIT 1 [ RunTime:0.001143s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668650 [ RunTime:0.001042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415089,971594,62361,17284,260947,640093,818371,931075,25291,705237,146890,39080,973276,792122,919591,272502,1033717,888446,105892,533788,860430,200674,692115,613030,561246,780369,484016,1048571,209725,24193,1029518,334030,200475,465546,628444,441755,27033,759613,705319,1020899,528195,16385,415241,299740,751440,617475,944382,833925,1038617,165904,941531,64646,575871,162661,465280,118744,996151,628807,39424,191674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]