SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200870 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200870 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439513,390814,662265,1041570,721769,904473,51081,548099,352839,470263,333667,351084,351856,9918,961561,545771,320716,697947,387779,94390,28491,972279,163785,855512,599449,289446,668003,1043152,870652,600979,200041,812922,733933,649432,551568,597986,904259,67094,1022065,223446,497271,501620,1046602,865726,364659,504236,350789,704171,206647,404564,841656,438903,123655,74562,430324,665730,169018,450222,332379,695415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]