SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020430 LIMIT 1 [ RunTime:0.001195s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020430 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191750,500037,884076,122660,443121,995321,49799,83614,661996,406524,294619,431344,928291,539083,935171,647974,544468,324424,318835,655072,875713,654021,972424,586423,928578,209306,525693,513223,301143,478909,116369,191062,828499,716251,792872,531336,555137,121317,93521,728312,706044,63446,491278,992708,210843,585115,922506,658978,808346,977466,475553,825436,126227,732754,205685,996630,812108,953086,920941,260330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]