SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200682 LIMIT 1 [ RunTime:0.000969s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200682 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954933,809182,902202,867935,775607,35034,985530,656192,114072,946029,179203,10930,191297,792385,72489,291472,245538,887090,764668,1047621,755640,501326,278795,507603,1001352,133709,372858,18972,187488,20892,30847,154413,835197,887808,403898,829107,643973,12278,806777,789155,119513,753742,161618,527656,178749,751085,62649,300575,107468,566903,289949,713248,296694,979356,59678,1000339,979374,449587,848771,46798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]