SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004988 LIMIT 1 [ RunTime:0.000596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004988 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282294,178287,681509,758915,190414,9723,673894,201589,109578,992834,616902,876108,585973,404633,515677,561595,1011680,875846,682872,768906,102964,467572,375829,127341,950482,174149,482594,391855,826111,768801,234392,904626,814656,1044038,146694,367831,856824,495488,316709,993920,130840,876184,197774,944005,723470,266167,827702,295450,920631,1032980,463021,227233,123382,754149,991875,627488,361728,620225,221315,247102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]