SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494018 LIMIT 1 [ RunTime:0.001989s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494018 [ RunTime:0.003797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979505,93508,545207,614010,754457,819777,953994,945736,442130,1014946,906449,269964,856580,515528,108201,771909,785046,832693,377863,555393,346956,295994,214917,583017,287199,766934,883846,617026,344053,419641,372558,552460,103736,142094,19309,468558,489059,82308,695631,353194,699556,67465,976898,420653,548744,925526,771146,339165,1045567,622494,803248,470417,600517,362904,344366,927935,684276,121209,810957,715417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]