SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597010 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597010 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701572,5776,798576,1011711,26897,732620,564517,11368,990682,749752,435097,606053,79312,890767,333943,124095,226842,895047,307064,577145,820187,599282,725930,93342,5352,791060,196636,874804,593398,55107,283,231750,422364,64272,966627,1010598,587935,103885,32464,210011,107166,318698,1034792,762230,365344,421806,835456,34789,483158,175969,866652,192955,982482,497104,785141,49741,766456,958748,1047631,560054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]