SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354570 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354570 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237913,233898,859055,277449,1031790,292691,170278,757529,445602,536188,898598,1037016,218142,559661,323912,242247,113239,99509,95751,460422,45993,262711,284863,645148,538300,757485,277055,191965,702638,908090,399276,643405,185293,249593,298217,791817,480202,746604,1047617,502191,765817,518456,467021,469058,24674,153951,762097,141866,55149,986457,822819,666577,970400,609517,583657,555411,801833,412968,259903,1015599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]