SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466243 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466243 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412476,308031,1031719,265819,184848,116807,11928,251957,291785,306190,941853,486598,195944,349210,644905,144570,510194,893575,287023,79903,296364,590191,672482,105482,164559,681782,505010,891327,160674,560274,864486,106421,496369,931234,123862,31908,637224,445992,181448,712371,420358,453595,324844,23285,451936,723080,901873,261223,896378,979948,295622,637246,54918,253207,194771,178807,189785,324685,880290,429520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]