SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500191 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500191 [ RunTime:0.004287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855211,1046118,354093,262425,470643,541862,572381,584207,687201,491820,836191,557810,585365,701290,116571,289233,303099,411085,398928,803326,353375,599390,796850,454687,170726,368408,598574,979298,597030,521894,583451,639810,290269,470423,222658,49561,786870,858008,875584,12698,336792,201667,734210,775164,357572,584083,734989,518644,334093,110502,986818,931424,592716,479107,711492,158139,258800,697930,624410,966295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]