SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42140 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42140 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760264,561822,527267,197421,923956,943497,355289,362421,354889,35584,9940,136899,259463,639742,294221,560609,166653,562403,919633,382192,200573,282885,532290,905872,330065,1026435,150049,609184,489976,640538,497512,922755,524730,600096,703441,350381,125894,99815,77443,87220,889768,96247,369133,732256,188411,864194,331827,271048,543144,138981,789853,692435,117646,358116,885015,310367,899751,484846,1016909,755327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]