SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541500 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541500 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141280,359218,903238,729352,717312,163350,506738,191,990370,392928,831450,373521,502072,482572,234795,146952,157494,370089,36871,303891,573899,835788,987702,890280,45523,110828,343038,1024224,25411,71163,554349,720676,418688,205170,550784,209457,891260,244849,341854,925379,561653,880858,1023239,765288,819809,281358,202472,388281,99668,585698,547339,101157,984812,116719,956400,356205,551496,878315,825530,432323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]