SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039715 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039715 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612300,180140,997857,785717,377051,1029045,860629,148279,952740,295713,280958,719716,773439,905611,830185,353822,443039,285779,637071,75374,449890,1003124,703628,366668,349613,936859,905172,948829,618581,936978,339696,324650,503643,50771,256857,471118,289277,609948,436605,1037264,976291,208202,51592,875737,315091,970332,870724,690076,288406,650128,132853,296486,689984,841798,690937,307368,740579,404214,550289,804536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]