SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507860 LIMIT 1 [ RunTime:0.001594s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507860 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98023,63417,143259,157745,37931,206401,362559,982436,132616,40613,714239,851051,725717,584246,980541,577028,551037,917040,19172,94689,891230,184699,1035154,1048126,977798,36022,1009869,1037349,197430,496014,629264,912651,65281,456401,941746,56077,782657,418615,193570,547223,18362,286883,535812,152846,239955,338096,262682,450717,416304,187676,469736,434177,807820,476890,166932,1005206,339270,915416,223794,850603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]