SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554396 LIMIT 1 [ RunTime:0.000566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554396 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664073,905260,655325,588813,434708,492180,775383,445960,536338,753681,1030022,908276,819109,389966,586254,834620,137673,954350,915970,1034007,253477,152360,81098,514125,282112,222743,676427,84840,506502,760142,832508,717710,703579,144801,777913,555574,714760,440093,135211,1041311,605921,136745,948568,225367,582003,102980,778539,366155,421905,459734,705329,655484,87040,457971,764110,989443,188684,584834,883206,529907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]