SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330040 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330040 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941593,6960,418773,143504,703435,805717,10960,450737,674351,186769,388201,247683,468098,286727,419251,363228,467293,580515,146703,183892,19423,593865,964609,227765,326757,577797,952035,582000,125809,399522,771213,182931,743522,222625,802005,539249,94035,413482,872414,338530,385063,224097,667811,1026418,106367,551170,152749,765332,1012838,700367,513338,1030903,477366,146816,54904,483663,407536,504624,807192,200769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]