SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682908 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682908 [ RunTime:0.003397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797469,301943,272398,116382,47092,702468,117893,976460,14463,341375,892099,846465,575817,744222,17864,616356,778520,1025532,499709,604261,866646,151908,469929,310364,927165,727440,895279,41768,489490,71999,588328,923483,873510,221677,577774,115687,698370,394573,932474,1046418,182697,282393,878434,422487,724583,149971,924536,698924,140360,751621,1036971,664253,240022,771472,931791,832871,19294,603847,616766,85198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]