SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46080 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46080 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437140,1047862,921596,1025384,484861,758850,264074,460348,330880,162465,653523,828027,674363,238924,141054,646271,1018708,800397,168064,939212,332209,997530,1013333,500096,441165,911620,398759,177634,519561,650848,91509,793304,174647,436625,331346,128118,6290,822492,77790,743099,9370,934291,606337,208640,242938,1031057,144303,994046,398420,136377,914760,145301,755842,56930,122334,931770,1047115,644479,196810,571824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]