SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29291 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29291 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736054,58238,907134,138581,59025,244547,803308,956453,712313,765944,558775,216087,1014508,749114,758772,108093,713227,502390,430638,1039170,95566,656278,242068,413022,681392,886234,881201,459300,141387,134365,503418,1024033,959840,344860,638207,1048183,84044,92969,639395,668593,287942,463110,566907,579144,117925,844282,437087,897520,860085,1008234,108252,622299,20139,142859,511934,292824,242492,933111,702774,981601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]