SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507612 LIMIT 1 [ RunTime:0.001525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507612 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428366,185200,474291,352998,610818,286294,226685,209996,375145,18108,341924,274603,117477,494421,147142,125670,203405,330428,439577,225165,785334,825032,537581,1015704,425637,987596,461007,313414,816719,3981,660469,777558,1021075,476760,870655,805708,277151,844672,480635,990925,855612,985340,516041,186766,846488,201987,642762,625485,445883,320383,1024090,235115,735848,788771,200386,1015285,507423,898183,896573,595652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]