SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147416 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147416 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45839,451854,88206,214951,744047,163055,236655,683685,276714,724826,110905,557894,1001433,242953,741127,392048,347065,926025,181774,183414,900762,4848,351340,123642,477603,455604,749203,1029843,284192,317718,450320,891986,1029180,619203,473689,80978,116212,212874,426188,300980,499873,520562,382762,946446,67804,559719,894525,559222,278048,333426,616709,128888,1025604,842725,1022035,743244,647906,276931,132744,358112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]