SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543638 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543638 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357682,477635,393424,502103,644609,755250,1013551,284596,957723,1022331,445283,718516,602201,260148,554697,545012,953315,750619,852522,358920,660210,419985,424520,1022814,1031223,1014245,883981,403621,867431,83709,317519,831167,101758,727738,591046,12328,272173,41816,736279,918550,503555,711846,420532,757719,471158,516937,314082,24001,221086,419952,905495,1020326,235523,983369,395825,838651,301037,321513,636369,753548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]