SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418513 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418513 [ RunTime:0.002773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469683,465592,120192,804745,367566,1023440,852595,138146,588966,465626,545655,492815,110921,775140,173743,1039556,156082,521647,413102,489730,286,305393,581438,1037889,412206,385109,189175,403539,813740,319708,254501,1011700,510564,946757,704293,831415,251335,515747,770106,74274,714613,797614,996708,323462,803359,47873,40846,120954,400898,708950,217925,589694,72121,940274,821927,925523,107834,864218,998101,417633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]