SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 828511 LIMIT 1 [ RunTime:0.001430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 828511 [ RunTime:0.001300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001781,853961,308102,886269,660775,303487,593164,681423,483134,731519,576127,471841,919408,92016,116393,906214,913294,137161,810733,483937,884308,270745,398492,397625,630367,206490,568426,168630,382323,613735,1003267,890011,718416,81563,913006,361349,894092,900100,784796,366768,714921,547763,808383,71506,801092,673224,667893,918763,836175,732022,992881,819710,403505,630101,493927,322803,346184,321785,554385,62405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 828511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 828511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]