SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047291 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047291 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139581,932854,459725,341702,535268,890375,412972,813879,813036,108618,640048,633507,922742,343636,393031,510070,47843,126474,797481,470333,908109,808289,240367,312145,771313,631085,938274,546650,555880,246424,607905,409046,828824,812567,1010375,546095,842742,439075,569532,143721,334371,461907,590149,1036254,151455,644856,235460,158420,786330,922971,878318,474772,728587,593444,839585,478686,485906,202903,1014068,312986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005131s ]