SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502422 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502422 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761926,650740,452371,451243,136821,160788,717250,952502,1022564,648283,529227,135178,143809,802846,167068,145169,870876,229305,432034,743555,1004952,479956,964860,26614,975701,36519,56542,325024,952065,716684,221771,830379,791258,255438,500394,830726,496485,629770,171795,240326,1048424,1006084,321992,834863,455736,811177,372688,249063,814863,940400,468729,414431,63397,628606,222719,825656,193337,92590,672363,195295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]